🕷️️ Job Radar • SCRAPING

freelancer.com 🟡 2026-05-08

🔹 Technical Manifest - Portable Multi-League Box-Score Database
👤 Client: 🇺🇸 Ypsilanti, United States Member since 2026-05-08
💰 Price: $187 Average bid
🚩 Problem: Build a single SQLite database with normalized schema to store regulation-time box scores for six leagues: NFL, NHL, MLB, NBA, Men’s NCAA Division I Football, and Men’s NCAA Division I Basketball.
📦 Existing: Not specified

Specifications:

[Format] - Single SQLite (.db) file containing historical data from the last 5 years (excluding post-season).
[Target] - Historical box scores for MLB starting April 2023, and other sports from the beginning of their respective 2021 regular seasons.
[Method] - Data collection through web scraping or API if available. Ensure no overtime or extra innings data is included.
[UI/UX] - Not applicable as this is a backend database project.
[Stack] - Python for web scraping (if necessary), SQLite for storage, SQL for querying.
[Security] - Basic security measures to protect the database file from unauthorized access. No need for complex authentication mechanisms.
[Format] - Data should be structured in a normalized schema with team totals and period/inning splits.

Workflow:

1. Define the schema: Create tables for each league, including columns for teams, periods/innings, scores, etc., ensuring normalization.
2. Populate the database: Use Python to scrape data from relevant sources (websites or APIs) and insert it into the SQLite database following the defined schema.
3. Validate the data: Ensure all box scores are accurate by cross-referencing with official league records if possible.
4. Document the process: Provide a step-by-step guide on how to populate future seasons, including any necessary scripts or commands.